package com.trmp.base.sceneryMng.dao.impl;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.springframework.data.jpa.repository.Modifying;

public class SceneryPriceInfoDaoImpl
{	
	@PersistenceContext
	private EntityManager em;

	@Modifying
	public void deleteByScenery(String checkedSceneryIdListStr)
	{
		
		String deleteSceneryPriceStr = "delete from T_BASE_SCENERY_PRICE where SCENERY_ID in ("+checkedSceneryIdListStr+")";
		Query querySceneryPrice = em.createNativeQuery(deleteSceneryPriceStr);
		querySceneryPrice.executeUpdate();
	}
	
}
